[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS * < ORDER BY OrderDate.YearMonth()Id
38 items
OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
---|---|---|---|---|---|---|---|
_SUM | 29.4M | 9.1M | 1.8M | 238K | 181K | 3.4M | 14.7M |
2021-10 | 473K | 210K | 22.0K | 35.6K | 40.2K | 37.5K | 128K |
2021-11 | 485K | 212K | 25.5K | 37.2K | 14.8K | 54K | 141K |
2021-12 | 495K | 185K | 21.3K | 25.7K | 39.7K | 63K | 161K |
2022-01 | 513K | 218K | 11.9K | 40.2K | 11.4K | 55K | 176K |
2022-02 | 508K | 193K | 29.8K | 43.4K | 29.6K | 23.4K | 188K |
2022-03 | 745K | 281K | 36.3K | 48.7K | 44.8K | 54K | 280K |
2022-04 | 583K | 212K | 46.8K | 7.0K | 0 | 71K | 246K |
2022-05 | 611K | 186K | 61K | 0 | 0 | 51K | 313K |
2022-06 | 630K | 229K | 24.8K | 0 | 0 | 36.1K | 340K |
2022-07 | 678K | 228K | 71K | 0 | 0 | 35.4K | 343K |
2022-08 | 674K | 206K | 46.1K | 0 | 0 | 26.1K | 396K |
2022-09 | 677K | 210K | 65K | 0 | 0 | 42.9K | 359K |
2022-10 | 500K | 131K | 42.1K | 0 | 0 | 42.6K | 285K |
2022-11 | 523K | 140K | 37.7K | 0 | 0 | 62K | 283K |
2022-12 | 374K | 126K | 15.2K | 0 | 0 | 54K | 178K |
2023-01 | 415K | 188K | 16.3K | 0 | 0 | 50K | 161K |
2023-02 | 309K | 97K | 9.2K | 0 | 0 | 43.5K | 159K |
2023-03 | 577K | 197K | 23.9K | 0 | 0 | 74K | 282K |
2023-04 | 426K | 188K | 12.2K | 0 | 0 | 62K | 164K |
2023-05 | 529K | 221K | 21.5K | 0 | 0 | 70K | 216K |
2023-06 | 465K | 192K | 28.2K | 0 | 0 | 60K | 185K |
2023-07 | 527K | 212K | 11.9K | 0 | 0 | 51K | 252K |
2023-08 | 563K | 204K | 30.2K | 0 | 0 | 71K | 258K |
2023-09 | 555K | 203K | 5.7K | 0 | 0 | 57K | 289K |
2023-10 | 887K | 253K | 39.9K | 0 | 0 | 131K | 463K |
2023-11 | 822K | 183K | 60K | 0 | 0 | 122K | 457K |
2023-12 | 1.0M | 331K | 63K | 0 | 0 | 132K | 509K |
2024-01 | 1.1M | 344K | 47.8K | 0 | 0 | 156K | 533K |
2024-02 | 1.2M | 329K | 91K | 0 | 0 | 164K | 579K |
2024-03 | 1.7M | 377K | 120K | 0 | 0 | 221K | 990K |
2024-04 | 1.3M | 380K | 112K | 0 | 0 | 167K | 659K |
2024-05 | 1.5M | 429K | 91K | 0 | 0 | 187K | 835K |
2024-06 | 1.4M | 388K | 86K | 0 | 0 | 199K | 757K |
2024-07 | 1.7M | 455K | 107K | 0 | 0 | 191K | 907K |
2024-08 | 1.9M | 436K | 138K | 0 | 0 | 209K | 1.1M |
2024-09 | 1.9M | 480K | 133K | 0 | 0 | 263K | 1.1M |
2024-10 | 51K | 222 | 472 | 0 | 0 | 51 | 50K |
Generated 2024-10-31 23:32:10.837 UTC